﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;

namespace DoAnQuamLy.DataAccess
{
    class DanhMucPhieuThuChiData
    {
        sqlDataProvider sdp = new sqlDataProvider();
        public DataTable Danhmucphieuthu()
        {
            SqlCommand cmd = new SqlCommand("Select Ngay, Sophieuthu, Nguoinoptien, Sotien, Lidothu from Phieuthutien");
            sdp.Load(cmd);
            return sdp;
        }
        public DataTable Danhmucphieuchi()
        {
            SqlCommand cmd = new SqlCommand("Select Ngay, Sophieuchi, Sotien, Nguoinhan, Lidochi from Phieuchitien");
            sdp.Load(cmd);
            return sdp;
        }
        public void Update()
        {
            sdp.Update();
        }
    }
}
